package com.justdoit.facedemo.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface EchartMapper {
    //查询所有用户
    @Select(" select count(*) from user_table")
    public int AllPeople();

    //未审核
    @Select(" select count(state) from meeting_minutes where state = \"未审核\"")
    public int weiShengHe();

    //审核通过
    @Select(" select count(state) from meeting_minutes where state = \"审核通过\"")
    public int ShengHeTongGuo();

    //已结束
    @Select(" select count(state) from meeting_minutes where state = \"已结束\"")
    public int YiJieShu();

    //已取消
    @Select(" select count(state) from meeting_minutes where state = \"已取消\"")
    public int YiQuXiao();

    //已签到
    @Select(" select count(state) from punch_card where state = \"已签到\"")
    public int YiQianDao();

    //未签到
    @Select(" select count(state) from punch_card where state = \"未签到\"")
    public int WeiQianDao();

    //补签
    @Select(" select count(state) from punch_card where state = \"补签\"")
    public int BuQian();

    //人脸签到
    @Select(" select count(method) from punch_card where method = \"人脸签到\"")
    public int RenLianQianDao();

    //图片签到
    @Select(" select count(method) from punch_card where method = \"图片签到\"")
    public int TuPianQianDao();

}
